A Structured Methodology for Spreadsheet Modelling
نویسندگان
چکیده
In this paper, we discuss the problem of the software engineering of a class of business spreadsheet models. A methodology for structured software development is proposed, which is based on structured analysis of data, represented as Jackson diagrams. It is shown that this analysis allows a straightforward modularisation, and that individual modules may be represented with indentation in the block-structured form of structured programs. The benefits of structured format are discussed, in terms of comprehensibility, ease of maintenance, and reduction in errors. The capability of the methodology to provide a modular overview in the model is described, and examples are given. The potential for a reverse-engineering tool, to transform existing spreadsheet models is discussed.
منابع مشابه
Developing a Repeating Model Using the Structured Spreadsheet Modelling and Implementation Methodology
Spreadsheets often have variables and formulas that are similar, differing only by the fact that they refer to different instances of an entity. For example, the calculation of the sales revenues of the South and East regions are Revenues South = Price*Quantity Sold South and Revenues East =Price*Quantity Sold East. In this paper, we present a conceptual modelling approach that takes advantage ...
متن کاملAn Evaluation of a Structured Spreadsheet Development Methodology
This paper presents the results of an empirical evaluation of the quality of a structured methodology for the development of spreadsheet models, proposed in numerous previous papers by Rajalingham K, Knight B and Chadwick D et al. This paper also describes an improved version of their methodology, supported by appropriate examples. The principal objective of a structured and disciplined methodo...
متن کاملStructured Spreadsheet Modeling and Implementation
Developing an error-free spreadsheet has been a problem since the beginning of end-user computing. In this paper, we present a methodology that separates the modeling from the implementation. Using proven techniques from Information Systems and Software Engineering, we develop strict, but simple, rules governing the implementation from the model. The resulting spreadsheet should be easier to un...
متن کاملStructured Spreadsheet Modelling and Implementation with Multiple Dimensions - Part 1: Modelling
Dimensions are an integral part of many models we use every day. Without thinking about it, we frequently use the time dimension: many financial and accounting spreadsheets have columns representing months or years. Representing a second dimension is often done by repeating blocs of formulas in a worksheet of creating multiple worksheets with the same structure.
متن کاملFactors Influencing Risks and Outcomes in End-User Development
End-user developed applications introduce many control risks into organizations. Literature suggests that influencing factors include developer experience, design approach, application type, problem complexity, t ime pressure, and presence or absence of reviav procedures. This research explores the impacts of diffeTent design approaches through two field experiments evaluating the use versus no...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
- CoRR
دوره abs/0805.4218 شماره
صفحات -
تاریخ انتشار 2008